Describes the range type features and PostgreSQL features in postgresql.
A new feature of PostgreSQL 9.2 is the range type range types. With this name, you can easily guess the purpose of this type. It allows you to define a value range for a column
Here we will introduce more concepts. Our exampleProgramYesOpenclTo realize gradient color coloring of a square. Here, we will involve variable storage attributes. We also introduce vector data, how vector data is operated, and how vector data is
Spare some time to write a blog post, hoping to help new contacts. I'm here today to learn a little bit about function types
Here is a description of the program function in OpenCL, the program function is usually in textual form, and then the
PostgreSQL has a wide range of data types available. Users can use the CREATE type command to Add new data types to PostgreSQL. Table 8-1 shows all the built-in common data types. Most of the optional names listed in the aliases column are names
PostgreSQL Type
the default. NET type
specific types of offers
other. NET Types
bool
bool
Int2
Short
BYTE, sbyte, int, long, float, double, decimal, string
A new feature of PostgreSQL 9.2 is the range type range types, by which you can easily guess the purpose of the type, which allows you to define a range of values for a column of data.
This simple feature lets us not define two fields to describe
1. Common Types
Other seller types
MySQL type
Bool,
Tinyint (1)
Boolean
Tinyint (1)
Char varying (M)
Varchar (M)
Dec
Decimal
Fixed
Decimal
Float4
Float
Test table/*Navicat Premium Data Transfer source server:localhost Source Server type:postgresql Source server Vers ion:90401 source Host:localhost Source Database:mmc source Schema:public Target Server Typ E:postgresql Target Server version:90401
~ ~ ~ Noodles ~ ~ ~ExercisesTo observe the data range, this should be a complex O (n) problem. Take the maximum as an example, consider a monotonic queue and maintain a monotonically decreasing queue. From the previous sweep, each answer to take the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.